package atguigu;

import java.io.File;
import java.nio.charset.Charset;
import java.util.ArrayList;
import java.util.List;

import cn.hutool.core.io.FileUtil;



public class Sql {

	public static void main(String[] args) {
		File file = new File("D:\\MyData\\ex_yejing1\\Desktop\\EQUIPSCADANODE.sql");
		File file2 = new File("D:\\MyData\\ex_yejing1\\Desktop\\EQUIPSCADANODE2.sql");
		List<String> readLines = FileUtil.readLines(file, Charset.forName("UTF-8"));
		List<String> lines = new ArrayList<String>();
		for (String string : readLines) {
			if(string.endsWith("VALUES")) continue;	
			lines.add(string);
		}
		
		FileUtil.writeLines(lines, file2, Charset.forName("UTF-8"));
	}
}
